<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.50.1600.1">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementText="UPDATE [People] set [age] = @1  WHERE [firstname]=@2" StatementId="1" StatementCompId="1" StatementType="UPDATE" StatementSubTreeCost="0.0132858" StatementEstRows="1" StatementOptmLevel="TRIVIAL" QueryHash="0xCA5324F3FBC9BA9F" QueryPlanHash="0xE40A89F1DCC0E3C2">
          <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/>
          <QueryPlan DegreeOfParallelism="0" CachedPlanSize="16" CompileTime="38" CompileCPU="4" CompileMemory="112">
            <RelOp NodeId="0" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0132858" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList/>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
              </RunTimeInformation>
              <Assert StartupExpression="0">
                <RelOp NodeId="1" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="1" EstimateIO="0.01" EstimateCPU="1e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0132857" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                  <OutputList>
                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
                  </RunTimeInformation>
                  <Update DMLRequestSort="0">
                    <Object Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Index="[PK_People_id]" IndexKind="Clustered"/>
                    <SetPredicate>
                      <ScalarOperator ScalarString="[StackOverflow].[dbo].[People].[age] = [@1]">
                        <ScalarExpressionList>
                          <ScalarOperator>
                            <MultipleAssign>
                              <Assign>
                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Column="@1"/>
                                  </Identifier>
                                </ScalarOperator>
                              </Assign>
                            </MultipleAssign>
                          </ScalarOperator>
                        </ScalarExpressionList>
                      </ScalarOperator>
                    </SetPredicate>
                    <RelOp NodeId="2" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00328466" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                      <OutputList>
                        <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="id"/>
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
                      </RunTimeInformation>
                      <Top RowCount="1" IsPercent="0" WithTies="0">
                        <TopExpression>
                          <ScalarOperator ScalarString="(0)">
                            <Const ConstValue="(0)"/>
                          </ScalarOperator>
                        </TopExpression>
                        <RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001592" AvgRowSize="22" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                          <OutputList>
                            <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="id"/>
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1"/>
                          </RunTimeInformation>
                          <IndexScan Ordered="1" ForcedIndex="0" NoExpandHint="0">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="id"/>
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Index="[PK_People_id]" IndexKind="Clustered"/>
                            <Predicate>
                              <ScalarOperator ScalarString="[StackOverflow].[dbo].[People].[firstname]=[@2]">
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="firstname"/>
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="@2"/>
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Predicate>
                          </IndexScan>
                        </RelOp>
                      </Top>
                    </RelOp>
                  </Update>
                </RelOp>
                <Predicate>
                  <ScalarOperator ScalarString="CASE WHEN [StackOverflow].[dbo].[People].[age]&lt;(0) OR [StackOverflow].[dbo].[People].[age]&gt;=(200) THEN (0) ELSE NULL END">
                    <IF>
                      <Condition>
                        <ScalarOperator>
                          <Logical Operation="OR">
                            <ScalarOperator>
                              <Compare CompareOp="LT">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                                  </Identifier>
                                </ScalarOperator>
                                <ScalarOperator>
                                  <Const ConstValue="(0)"/>
                                </ScalarOperator>
                              </Compare>
                            </ScalarOperator>
                            <ScalarOperator>
                              <Compare CompareOp="GE">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[StackOverflow]" Schema="[dbo]" Table="[People]" Column="age"/>
                                  </Identifier>
                                </ScalarOperator>
                                <ScalarOperator>
                                  <Const ConstValue="(200)"/>
                                </ScalarOperator>
                              </Compare>
                            </ScalarOperator>
                          </Logical>
                        </ScalarOperator>
                      </Condition>
                      <Then>
                        <ScalarOperator>
                          <Const ConstValue="(0)"/>
                        </ScalarOperator>
                      </Then>
                      <Else>
                        <ScalarOperator>
                          <Const ConstValue="NULL"/>
                        </ScalarOperator>
                      </Else>
                    </IF>
                  </ScalarOperator>
                </Predicate>
              </Assert>
            </RelOp>
            <ParameterList>
              <ColumnReference Column="@1" ParameterCompiledValue="(42)" ParameterRuntimeValue="(42)"/>
              <ColumnReference Column="@2" ParameterCompiledValue="&apos;Thursday&apos;" ParameterRuntimeValue="&apos;Thursday&apos;"/>
            </ParameterList>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>